/*
CREATE TABLE "base_de_zs_cg_relation" (
  "sequence_nbr" varchar PRIMARY KEY NOT NULL,
  "storey" varchar,
  "zs_de_code" varchar,
  "cg_de_code" varchar,
  "location" varchar,
  "rec_user_code" varchar,
  "rec_status" varchar DEFAULT ('A'),
  "rec_date" varchar,
  "extend1" varchar,
  "extend2" varchar,
  "extend3" varchar,
  "description" varchar
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct BaseDeZsCgRelation {
    pub sequence_nbr: String,
    pub storey: Option<String>,
    pub zs_de_code: Option<String>,
    pub cg_de_code: Option<String>,
    pub location: Option<String>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<String>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub description: Option<String>,
}
crud!(BaseDeZsCgRelation {}, "base_de_zs_cg_relation");
